Student Solution

-->

"Education is the most powerful weapon which you can use to change the world”
– Nelson Mandela

1 University

1 Course

2 Subjects

Assignment-05-Excel Data Visualization

Assignment-05-Excel Data Visualization

Q Assignment 1 ? Download the provided data file from the course web site. ? Task ? Read data in Table 1 using openpyxl and draw a bar chart using matplotlib. ? Read data in Table 2 using openpyxl and draw a pie chart using matplotlib. Explode Part 2.

View Related Questions

Solution Preview

# -*- coding: utf-8 -*- """ Created on Fri Mar 12 10:24:42 2021 @author: wcraw """ import matplotlib.pyplot as plt import openpyxl as oxl ELH_wb = oxl. load_workbook("Assignment-05-ExcelDataVisualization.xlsx") ELH_sheet = ELH_wb["Sheet1"] ELH_label = [] ELH_y =[] ELH_label2 = [] ELH_z = [] ELH_explode = [0,0.1,0,0]